<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@page import="util.DBUtils"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.util.List"%>
<%@page import="java.util.Map"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%
Connection c = DBUtils.getConnction("jdbc/trswcm");
String sql = "SELECT TOP 1 TEMPTEXT FROM WCMTEMPLATE WHERE ROOTID = 2";
Statement s = c.createStatement();
ResultSet rs = s.executeQuery(sql);
System.out.println(DBUtils.types.get(DBUtils.getColumnTypes(rs).get("TEMPTEXT")));
rs.next();
System.out.println(rs.getString("TEMPTEXT"));
DBUtils.close(rs);
DBUtils.close(s);
DBUtils.close(c);
%>